Skip to main content

Create Dataset using CSV

  • From this document, you will learn to create a dataset in OPNBI, Moreover, you will learn to make a dataset using CSV(Comma-separated values).

What is CSV?​

  • A comma-separated values file is a delimited text file that uses a comma to separate values & that file is a plain text file that contains a list of data. These files are often used for exchanging data between different application. Each line of the file is a data record. Each record consists of one or more fields, separated by commas. The use of the comma as a field separator is the source of the name for this file format.

  • Click here to know more about CSV files.

Objectives​

  • Create dataset using CSV File

Prerequisites​

  • For this example we are using employees.csv

Download csv.zip file from link given csv.zip

  • After downloading the zip file, add it into the OPNBI. To add it into OPNBI follow this Link.

Dataset using CSV: This video contains how to create Dataset using CSV in OPNBI.

Steps to create dataset using CSV​

  1. Click on Hamburger Icon & go to Documents Tab.

    Docusaurus Slash Introduction

  2. In Documents tab Click on Shared Resource.

  3. In Shared Resource Click on upload, As shown in figure below:

    Docusaurus Slash Introduction

  4. When you click on Upload it will display a screen.

  5. In Upload Files upload a csv file, As shown in figure below:

    Docusaurus Slash Introduction

  6. Click on Upload button.

  7. You will get a message, As shown in figure below:

    Docusaurus Slash Introduction

  8. In Master Data Tab click on Dataset.

  9. Click on create dataset, As shown in figure below:

    Docusaurus Slash Introduction

  10. Enter following details in Create Dataset.

  • Name: Employee
  • Datasource: Existing Files
  • Select Employee.csv file in Available to selected.

  1. Fill above details, As shown in figure below:

    Docusaurus Slash Introduction

  2. Click on the Select from the center of the screen & then click on Preview and Submit button.

  3. You will see the Employee Dataset, As shown in figure below:

    Docusaurus Slash Introduction

  4. Click on Hamburger menu > Dashboard section & open your dashboard.

    Docusaurus Slash Introduction

  1. From Right Vertical Menu Select the Table Widget icon for this example.

    Docusaurus Slash Introduction

info
  • Click here to know more about different dashboard widgets.

  1. The Edit menu box appears as you click Table Widget icon. And a widget gets added in content place automatically in dashboard.

  2. Enter Following Details in edit box, As shown in figure below:

  • Dataset: Employee.ds
  • Select all the Field in Dataset Column.

  1. Fill above details, As shown in figure below:

    Docusaurus Slash Introduction

  2. Click on Preview and Save and Exit button.

  3. Now, match your Table Widget with the below example, it should look like the figure below:

    Docusaurus Slash Introduction

To know more about how to create dataset using different sources follow below Links:-

Dataset using Excel​

Dataset using JSON​

Dataset using Flatfiles​

Dataset using External sources​

Dataset using Google BigQuery​

Dataset using noSQL ​

Dataset using Join​

Dataset using Union​

Dataset using Server Script​

Dataset using Client Script​

Dataset using Stored Procedure​

Dataset using View​

Dataset using Simple Query​

Dataset using Drag & Drop​